package com.desksoft.ecommerce.entity.logistics.dto;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class StoragedExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public StoragedExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andStorageaccnoIsNull() {
            addCriterion("StorageAccNo is null");
            return (Criteria) this;
        }

        public Criteria andStorageaccnoIsNotNull() {
            addCriterion("StorageAccNo is not null");
            return (Criteria) this;
        }

        public Criteria andStorageaccnoEqualTo(String value) {
            addCriterion("StorageAccNo =", value, "storageaccno");
            return (Criteria) this;
        }

        public Criteria andStorageaccnoNotEqualTo(String value) {
            addCriterion("StorageAccNo <>", value, "storageaccno");
            return (Criteria) this;
        }

        public Criteria andStorageaccnoGreaterThan(String value) {
            addCriterion("StorageAccNo >", value, "storageaccno");
            return (Criteria) this;
        }

        public Criteria andStorageaccnoGreaterThanOrEqualTo(String value) {
            addCriterion("StorageAccNo >=", value, "storageaccno");
            return (Criteria) this;
        }

        public Criteria andStorageaccnoLessThan(String value) {
            addCriterion("StorageAccNo <", value, "storageaccno");
            return (Criteria) this;
        }

        public Criteria andStorageaccnoLessThanOrEqualTo(String value) {
            addCriterion("StorageAccNo <=", value, "storageaccno");
            return (Criteria) this;
        }

        public Criteria andStorageaccnoLike(String value) {
            addCriterion("StorageAccNo like", value, "storageaccno");
            return (Criteria) this;
        }

        public Criteria andStorageaccnoNotLike(String value) {
            addCriterion("StorageAccNo not like", value, "storageaccno");
            return (Criteria) this;
        }

        public Criteria andStorageaccnoIn(List<String> values) {
            addCriterion("StorageAccNo in", values, "storageaccno");
            return (Criteria) this;
        }

        public Criteria andStorageaccnoNotIn(List<String> values) {
            addCriterion("StorageAccNo not in", values, "storageaccno");
            return (Criteria) this;
        }

        public Criteria andStorageaccnoBetween(String value1, String value2) {
            addCriterion("StorageAccNo between", value1, value2, "storageaccno");
            return (Criteria) this;
        }

        public Criteria andStorageaccnoNotBetween(String value1, String value2) {
            addCriterion("StorageAccNo not between", value1, value2, "storageaccno");
            return (Criteria) this;
        }

        public Criteria andDccodeIsNull() {
            addCriterion("DCCode is null");
            return (Criteria) this;
        }

        public Criteria andDccodeIsNotNull() {
            addCriterion("DCCode is not null");
            return (Criteria) this;
        }

        public Criteria andDccodeEqualTo(String value) {
            addCriterion("DCCode =", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeNotEqualTo(String value) {
            addCriterion("DCCode <>", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeGreaterThan(String value) {
            addCriterion("DCCode >", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeGreaterThanOrEqualTo(String value) {
            addCriterion("DCCode >=", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeLessThan(String value) {
            addCriterion("DCCode <", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeLessThanOrEqualTo(String value) {
            addCriterion("DCCode <=", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeLike(String value) {
            addCriterion("DCCode like", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeNotLike(String value) {
            addCriterion("DCCode not like", value, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeIn(List<String> values) {
            addCriterion("DCCode in", values, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeNotIn(List<String> values) {
            addCriterion("DCCode not in", values, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeBetween(String value1, String value2) {
            addCriterion("DCCode between", value1, value2, "dccode");
            return (Criteria) this;
        }

        public Criteria andDccodeNotBetween(String value1, String value2) {
            addCriterion("DCCode not between", value1, value2, "dccode");
            return (Criteria) this;
        }

        public Criteria andStorecodeIsNull() {
            addCriterion("StoreCode is null");
            return (Criteria) this;
        }

        public Criteria andStorecodeIsNotNull() {
            addCriterion("StoreCode is not null");
            return (Criteria) this;
        }

        public Criteria andStorecodeEqualTo(String value) {
            addCriterion("StoreCode =", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotEqualTo(String value) {
            addCriterion("StoreCode <>", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeGreaterThan(String value) {
            addCriterion("StoreCode >", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeGreaterThanOrEqualTo(String value) {
            addCriterion("StoreCode >=", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLessThan(String value) {
            addCriterion("StoreCode <", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLessThanOrEqualTo(String value) {
            addCriterion("StoreCode <=", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLike(String value) {
            addCriterion("StoreCode like", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotLike(String value) {
            addCriterion("StoreCode not like", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeIn(List<String> values) {
            addCriterion("StoreCode in", values, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotIn(List<String> values) {
            addCriterion("StoreCode not in", values, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeBetween(String value1, String value2) {
            addCriterion("StoreCode between", value1, value2, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotBetween(String value1, String value2) {
            addCriterion("StoreCode not between", value1, value2, "storecode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeIsNull() {
            addCriterion("DeptCode is null");
            return (Criteria) this;
        }

        public Criteria andDeptcodeIsNotNull() {
            addCriterion("DeptCode is not null");
            return (Criteria) this;
        }

        public Criteria andDeptcodeEqualTo(String value) {
            addCriterion("DeptCode =", value, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeNotEqualTo(String value) {
            addCriterion("DeptCode <>", value, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeGreaterThan(String value) {
            addCriterion("DeptCode >", value, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeGreaterThanOrEqualTo(String value) {
            addCriterion("DeptCode >=", value, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeLessThan(String value) {
            addCriterion("DeptCode <", value, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeLessThanOrEqualTo(String value) {
            addCriterion("DeptCode <=", value, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeLike(String value) {
            addCriterion("DeptCode like", value, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeNotLike(String value) {
            addCriterion("DeptCode not like", value, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeIn(List<String> values) {
            addCriterion("DeptCode in", values, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeNotIn(List<String> values) {
            addCriterion("DeptCode not in", values, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeBetween(String value1, String value2) {
            addCriterion("DeptCode between", value1, value2, "deptcode");
            return (Criteria) this;
        }

        public Criteria andDeptcodeNotBetween(String value1, String value2) {
            addCriterion("DeptCode not between", value1, value2, "deptcode");
            return (Criteria) this;
        }

        public Criteria andHousecodeIsNull() {
            addCriterion("HouseCode is null");
            return (Criteria) this;
        }

        public Criteria andHousecodeIsNotNull() {
            addCriterion("HouseCode is not null");
            return (Criteria) this;
        }

        public Criteria andHousecodeEqualTo(String value) {
            addCriterion("HouseCode =", value, "housecode");
            return (Criteria) this;
        }

        public Criteria andHousecodeNotEqualTo(String value) {
            addCriterion("HouseCode <>", value, "housecode");
            return (Criteria) this;
        }

        public Criteria andHousecodeGreaterThan(String value) {
            addCriterion("HouseCode >", value, "housecode");
            return (Criteria) this;
        }

        public Criteria andHousecodeGreaterThanOrEqualTo(String value) {
            addCriterion("HouseCode >=", value, "housecode");
            return (Criteria) this;
        }

        public Criteria andHousecodeLessThan(String value) {
            addCriterion("HouseCode <", value, "housecode");
            return (Criteria) this;
        }

        public Criteria andHousecodeLessThanOrEqualTo(String value) {
            addCriterion("HouseCode <=", value, "housecode");
            return (Criteria) this;
        }

        public Criteria andHousecodeLike(String value) {
            addCriterion("HouseCode like", value, "housecode");
            return (Criteria) this;
        }

        public Criteria andHousecodeNotLike(String value) {
            addCriterion("HouseCode not like", value, "housecode");
            return (Criteria) this;
        }

        public Criteria andHousecodeIn(List<String> values) {
            addCriterion("HouseCode in", values, "housecode");
            return (Criteria) this;
        }

        public Criteria andHousecodeNotIn(List<String> values) {
            addCriterion("HouseCode not in", values, "housecode");
            return (Criteria) this;
        }

        public Criteria andHousecodeBetween(String value1, String value2) {
            addCriterion("HouseCode between", value1, value2, "housecode");
            return (Criteria) this;
        }

        public Criteria andHousecodeNotBetween(String value1, String value2) {
            addCriterion("HouseCode not between", value1, value2, "housecode");
            return (Criteria) this;
        }

        public Criteria andBilldateIsNull() {
            addCriterion("BillDate is null");
            return (Criteria) this;
        }

        public Criteria andBilldateIsNotNull() {
            addCriterion("BillDate is not null");
            return (Criteria) this;
        }

        public Criteria andBilldateEqualTo(Date value) {
            addCriterion("BillDate =", value, "billdate");
            return (Criteria) this;
        }

        public Criteria andBilldateNotEqualTo(Date value) {
            addCriterion("BillDate <>", value, "billdate");
            return (Criteria) this;
        }

        public Criteria andBilldateGreaterThan(Date value) {
            addCriterion("BillDate >", value, "billdate");
            return (Criteria) this;
        }

        public Criteria andBilldateGreaterThanOrEqualTo(Date value) {
            addCriterion("BillDate >=", value, "billdate");
            return (Criteria) this;
        }

        public Criteria andBilldateLessThan(Date value) {
            addCriterion("BillDate <", value, "billdate");
            return (Criteria) this;
        }

        public Criteria andBilldateLessThanOrEqualTo(Date value) {
            addCriterion("BillDate <=", value, "billdate");
            return (Criteria) this;
        }

        public Criteria andBilldateIn(List<Date> values) {
            addCriterion("BillDate in", values, "billdate");
            return (Criteria) this;
        }

        public Criteria andBilldateNotIn(List<Date> values) {
            addCriterion("BillDate not in", values, "billdate");
            return (Criteria) this;
        }

        public Criteria andBilldateBetween(Date value1, Date value2) {
            addCriterion("BillDate between", value1, value2, "billdate");
            return (Criteria) this;
        }

        public Criteria andBilldateNotBetween(Date value1, Date value2) {
            addCriterion("BillDate not between", value1, value2, "billdate");
            return (Criteria) this;
        }

        public Criteria andBillnoIsNull() {
            addCriterion("BillNo is null");
            return (Criteria) this;
        }

        public Criteria andBillnoIsNotNull() {
            addCriterion("BillNo is not null");
            return (Criteria) this;
        }

        public Criteria andBillnoEqualTo(String value) {
            addCriterion("BillNo =", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoNotEqualTo(String value) {
            addCriterion("BillNo <>", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoGreaterThan(String value) {
            addCriterion("BillNo >", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoGreaterThanOrEqualTo(String value) {
            addCriterion("BillNo >=", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoLessThan(String value) {
            addCriterion("BillNo <", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoLessThanOrEqualTo(String value) {
            addCriterion("BillNo <=", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoLike(String value) {
            addCriterion("BillNo like", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoNotLike(String value) {
            addCriterion("BillNo not like", value, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoIn(List<String> values) {
            addCriterion("BillNo in", values, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoNotIn(List<String> values) {
            addCriterion("BillNo not in", values, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoBetween(String value1, String value2) {
            addCriterion("BillNo between", value1, value2, "billno");
            return (Criteria) this;
        }

        public Criteria andBillnoNotBetween(String value1, String value2) {
            addCriterion("BillNo not between", value1, value2, "billno");
            return (Criteria) this;
        }

        public Criteria andBillmodeIsNull() {
            addCriterion("BillMode is null");
            return (Criteria) this;
        }

        public Criteria andBillmodeIsNotNull() {
            addCriterion("BillMode is not null");
            return (Criteria) this;
        }

        public Criteria andBillmodeEqualTo(String value) {
            addCriterion("BillMode =", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeNotEqualTo(String value) {
            addCriterion("BillMode <>", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeGreaterThan(String value) {
            addCriterion("BillMode >", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeGreaterThanOrEqualTo(String value) {
            addCriterion("BillMode >=", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeLessThan(String value) {
            addCriterion("BillMode <", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeLessThanOrEqualTo(String value) {
            addCriterion("BillMode <=", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeLike(String value) {
            addCriterion("BillMode like", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeNotLike(String value) {
            addCriterion("BillMode not like", value, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeIn(List<String> values) {
            addCriterion("BillMode in", values, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeNotIn(List<String> values) {
            addCriterion("BillMode not in", values, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeBetween(String value1, String value2) {
            addCriterion("BillMode between", value1, value2, "billmode");
            return (Criteria) this;
        }

        public Criteria andBillmodeNotBetween(String value1, String value2) {
            addCriterion("BillMode not between", value1, value2, "billmode");
            return (Criteria) this;
        }

        public Criteria andItemcodeIsNull() {
            addCriterion("ItemCode is null");
            return (Criteria) this;
        }

        public Criteria andItemcodeIsNotNull() {
            addCriterion("ItemCode is not null");
            return (Criteria) this;
        }

        public Criteria andItemcodeEqualTo(String value) {
            addCriterion("ItemCode =", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeNotEqualTo(String value) {
            addCriterion("ItemCode <>", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeGreaterThan(String value) {
            addCriterion("ItemCode >", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeGreaterThanOrEqualTo(String value) {
            addCriterion("ItemCode >=", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeLessThan(String value) {
            addCriterion("ItemCode <", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeLessThanOrEqualTo(String value) {
            addCriterion("ItemCode <=", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeLike(String value) {
            addCriterion("ItemCode like", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeNotLike(String value) {
            addCriterion("ItemCode not like", value, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeIn(List<String> values) {
            addCriterion("ItemCode in", values, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeNotIn(List<String> values) {
            addCriterion("ItemCode not in", values, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeBetween(String value1, String value2) {
            addCriterion("ItemCode between", value1, value2, "itemcode");
            return (Criteria) this;
        }

        public Criteria andItemcodeNotBetween(String value1, String value2) {
            addCriterion("ItemCode not between", value1, value2, "itemcode");
            return (Criteria) this;
        }

        public Criteria andPacksizeIsNull() {
            addCriterion("PackSize is null");
            return (Criteria) this;
        }

        public Criteria andPacksizeIsNotNull() {
            addCriterion("PackSize is not null");
            return (Criteria) this;
        }

        public Criteria andPacksizeEqualTo(BigDecimal value) {
            addCriterion("PackSize =", value, "packsize");
            return (Criteria) this;
        }

        public Criteria andPacksizeNotEqualTo(BigDecimal value) {
            addCriterion("PackSize <>", value, "packsize");
            return (Criteria) this;
        }

        public Criteria andPacksizeGreaterThan(BigDecimal value) {
            addCriterion("PackSize >", value, "packsize");
            return (Criteria) this;
        }

        public Criteria andPacksizeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PackSize >=", value, "packsize");
            return (Criteria) this;
        }

        public Criteria andPacksizeLessThan(BigDecimal value) {
            addCriterion("PackSize <", value, "packsize");
            return (Criteria) this;
        }

        public Criteria andPacksizeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PackSize <=", value, "packsize");
            return (Criteria) this;
        }

        public Criteria andPacksizeIn(List<BigDecimal> values) {
            addCriterion("PackSize in", values, "packsize");
            return (Criteria) this;
        }

        public Criteria andPacksizeNotIn(List<BigDecimal> values) {
            addCriterion("PackSize not in", values, "packsize");
            return (Criteria) this;
        }

        public Criteria andPacksizeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PackSize between", value1, value2, "packsize");
            return (Criteria) this;
        }

        public Criteria andPacksizeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PackSize not between", value1, value2, "packsize");
            return (Criteria) this;
        }

        public Criteria andPriceIsNull() {
            addCriterion("Price is null");
            return (Criteria) this;
        }

        public Criteria andPriceIsNotNull() {
            addCriterion("Price is not null");
            return (Criteria) this;
        }

        public Criteria andPriceEqualTo(BigDecimal value) {
            addCriterion("Price =", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotEqualTo(BigDecimal value) {
            addCriterion("Price <>", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThan(BigDecimal value) {
            addCriterion("Price >", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Price >=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThan(BigDecimal value) {
            addCriterion("Price <", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Price <=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceIn(List<BigDecimal> values) {
            addCriterion("Price in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotIn(List<BigDecimal> values) {
            addCriterion("Price not in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Price between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Price not between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andNetpriceIsNull() {
            addCriterion("NetPrice is null");
            return (Criteria) this;
        }

        public Criteria andNetpriceIsNotNull() {
            addCriterion("NetPrice is not null");
            return (Criteria) this;
        }

        public Criteria andNetpriceEqualTo(BigDecimal value) {
            addCriterion("NetPrice =", value, "netprice");
            return (Criteria) this;
        }

        public Criteria andNetpriceNotEqualTo(BigDecimal value) {
            addCriterion("NetPrice <>", value, "netprice");
            return (Criteria) this;
        }

        public Criteria andNetpriceGreaterThan(BigDecimal value) {
            addCriterion("NetPrice >", value, "netprice");
            return (Criteria) this;
        }

        public Criteria andNetpriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("NetPrice >=", value, "netprice");
            return (Criteria) this;
        }

        public Criteria andNetpriceLessThan(BigDecimal value) {
            addCriterion("NetPrice <", value, "netprice");
            return (Criteria) this;
        }

        public Criteria andNetpriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("NetPrice <=", value, "netprice");
            return (Criteria) this;
        }

        public Criteria andNetpriceIn(List<BigDecimal> values) {
            addCriterion("NetPrice in", values, "netprice");
            return (Criteria) this;
        }

        public Criteria andNetpriceNotIn(List<BigDecimal> values) {
            addCriterion("NetPrice not in", values, "netprice");
            return (Criteria) this;
        }

        public Criteria andNetpriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("NetPrice between", value1, value2, "netprice");
            return (Criteria) this;
        }

        public Criteria andNetpriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("NetPrice not between", value1, value2, "netprice");
            return (Criteria) this;
        }

        public Criteria andGrnqtyIsNull() {
            addCriterion("GrnQty is null");
            return (Criteria) this;
        }

        public Criteria andGrnqtyIsNotNull() {
            addCriterion("GrnQty is not null");
            return (Criteria) this;
        }

        public Criteria andGrnqtyEqualTo(BigDecimal value) {
            addCriterion("GrnQty =", value, "grnqty");
            return (Criteria) this;
        }

        public Criteria andGrnqtyNotEqualTo(BigDecimal value) {
            addCriterion("GrnQty <>", value, "grnqty");
            return (Criteria) this;
        }

        public Criteria andGrnqtyGreaterThan(BigDecimal value) {
            addCriterion("GrnQty >", value, "grnqty");
            return (Criteria) this;
        }

        public Criteria andGrnqtyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("GrnQty >=", value, "grnqty");
            return (Criteria) this;
        }

        public Criteria andGrnqtyLessThan(BigDecimal value) {
            addCriterion("GrnQty <", value, "grnqty");
            return (Criteria) this;
        }

        public Criteria andGrnqtyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("GrnQty <=", value, "grnqty");
            return (Criteria) this;
        }

        public Criteria andGrnqtyIn(List<BigDecimal> values) {
            addCriterion("GrnQty in", values, "grnqty");
            return (Criteria) this;
        }

        public Criteria andGrnqtyNotIn(List<BigDecimal> values) {
            addCriterion("GrnQty not in", values, "grnqty");
            return (Criteria) this;
        }

        public Criteria andGrnqtyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("GrnQty between", value1, value2, "grnqty");
            return (Criteria) this;
        }

        public Criteria andGrnqtyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("GrnQty not between", value1, value2, "grnqty");
            return (Criteria) this;
        }

        public Criteria andAmtIsNull() {
            addCriterion("Amt is null");
            return (Criteria) this;
        }

        public Criteria andAmtIsNotNull() {
            addCriterion("Amt is not null");
            return (Criteria) this;
        }

        public Criteria andAmtEqualTo(BigDecimal value) {
            addCriterion("Amt =", value, "amt");
            return (Criteria) this;
        }

        public Criteria andAmtNotEqualTo(BigDecimal value) {
            addCriterion("Amt <>", value, "amt");
            return (Criteria) this;
        }

        public Criteria andAmtGreaterThan(BigDecimal value) {
            addCriterion("Amt >", value, "amt");
            return (Criteria) this;
        }

        public Criteria andAmtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Amt >=", value, "amt");
            return (Criteria) this;
        }

        public Criteria andAmtLessThan(BigDecimal value) {
            addCriterion("Amt <", value, "amt");
            return (Criteria) this;
        }

        public Criteria andAmtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Amt <=", value, "amt");
            return (Criteria) this;
        }

        public Criteria andAmtIn(List<BigDecimal> values) {
            addCriterion("Amt in", values, "amt");
            return (Criteria) this;
        }

        public Criteria andAmtNotIn(List<BigDecimal> values) {
            addCriterion("Amt not in", values, "amt");
            return (Criteria) this;
        }

        public Criteria andAmtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Amt between", value1, value2, "amt");
            return (Criteria) this;
        }

        public Criteria andAmtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Amt not between", value1, value2, "amt");
            return (Criteria) this;
        }

        public Criteria andNetamtIsNull() {
            addCriterion("NetAmt is null");
            return (Criteria) this;
        }

        public Criteria andNetamtIsNotNull() {
            addCriterion("NetAmt is not null");
            return (Criteria) this;
        }

        public Criteria andNetamtEqualTo(BigDecimal value) {
            addCriterion("NetAmt =", value, "netamt");
            return (Criteria) this;
        }

        public Criteria andNetamtNotEqualTo(BigDecimal value) {
            addCriterion("NetAmt <>", value, "netamt");
            return (Criteria) this;
        }

        public Criteria andNetamtGreaterThan(BigDecimal value) {
            addCriterion("NetAmt >", value, "netamt");
            return (Criteria) this;
        }

        public Criteria andNetamtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("NetAmt >=", value, "netamt");
            return (Criteria) this;
        }

        public Criteria andNetamtLessThan(BigDecimal value) {
            addCriterion("NetAmt <", value, "netamt");
            return (Criteria) this;
        }

        public Criteria andNetamtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("NetAmt <=", value, "netamt");
            return (Criteria) this;
        }

        public Criteria andNetamtIn(List<BigDecimal> values) {
            addCriterion("NetAmt in", values, "netamt");
            return (Criteria) this;
        }

        public Criteria andNetamtNotIn(List<BigDecimal> values) {
            addCriterion("NetAmt not in", values, "netamt");
            return (Criteria) this;
        }

        public Criteria andNetamtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("NetAmt between", value1, value2, "netamt");
            return (Criteria) this;
        }

        public Criteria andNetamtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("NetAmt not between", value1, value2, "netamt");
            return (Criteria) this;
        }

        public Criteria andTaxrateIsNull() {
            addCriterion("TaxRate is null");
            return (Criteria) this;
        }

        public Criteria andTaxrateIsNotNull() {
            addCriterion("TaxRate is not null");
            return (Criteria) this;
        }

        public Criteria andTaxrateEqualTo(BigDecimal value) {
            addCriterion("TaxRate =", value, "taxrate");
            return (Criteria) this;
        }

        public Criteria andTaxrateNotEqualTo(BigDecimal value) {
            addCriterion("TaxRate <>", value, "taxrate");
            return (Criteria) this;
        }

        public Criteria andTaxrateGreaterThan(BigDecimal value) {
            addCriterion("TaxRate >", value, "taxrate");
            return (Criteria) this;
        }

        public Criteria andTaxrateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("TaxRate >=", value, "taxrate");
            return (Criteria) this;
        }

        public Criteria andTaxrateLessThan(BigDecimal value) {
            addCriterion("TaxRate <", value, "taxrate");
            return (Criteria) this;
        }

        public Criteria andTaxrateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("TaxRate <=", value, "taxrate");
            return (Criteria) this;
        }

        public Criteria andTaxrateIn(List<BigDecimal> values) {
            addCriterion("TaxRate in", values, "taxrate");
            return (Criteria) this;
        }

        public Criteria andTaxrateNotIn(List<BigDecimal> values) {
            addCriterion("TaxRate not in", values, "taxrate");
            return (Criteria) this;
        }

        public Criteria andTaxrateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TaxRate between", value1, value2, "taxrate");
            return (Criteria) this;
        }

        public Criteria andTaxrateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TaxRate not between", value1, value2, "taxrate");
            return (Criteria) this;
        }

        public Criteria andTaxamtIsNull() {
            addCriterion("TaxAmt is null");
            return (Criteria) this;
        }

        public Criteria andTaxamtIsNotNull() {
            addCriterion("TaxAmt is not null");
            return (Criteria) this;
        }

        public Criteria andTaxamtEqualTo(BigDecimal value) {
            addCriterion("TaxAmt =", value, "taxamt");
            return (Criteria) this;
        }

        public Criteria andTaxamtNotEqualTo(BigDecimal value) {
            addCriterion("TaxAmt <>", value, "taxamt");
            return (Criteria) this;
        }

        public Criteria andTaxamtGreaterThan(BigDecimal value) {
            addCriterion("TaxAmt >", value, "taxamt");
            return (Criteria) this;
        }

        public Criteria andTaxamtGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("TaxAmt >=", value, "taxamt");
            return (Criteria) this;
        }

        public Criteria andTaxamtLessThan(BigDecimal value) {
            addCriterion("TaxAmt <", value, "taxamt");
            return (Criteria) this;
        }

        public Criteria andTaxamtLessThanOrEqualTo(BigDecimal value) {
            addCriterion("TaxAmt <=", value, "taxamt");
            return (Criteria) this;
        }

        public Criteria andTaxamtIn(List<BigDecimal> values) {
            addCriterion("TaxAmt in", values, "taxamt");
            return (Criteria) this;
        }

        public Criteria andTaxamtNotIn(List<BigDecimal> values) {
            addCriterion("TaxAmt not in", values, "taxamt");
            return (Criteria) this;
        }

        public Criteria andTaxamtBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TaxAmt between", value1, value2, "taxamt");
            return (Criteria) this;
        }

        public Criteria andTaxamtNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TaxAmt not between", value1, value2, "taxamt");
            return (Criteria) this;
        }

        public Criteria andYielddateIsNull() {
            addCriterion("YieldDate is null");
            return (Criteria) this;
        }

        public Criteria andYielddateIsNotNull() {
            addCriterion("YieldDate is not null");
            return (Criteria) this;
        }

        public Criteria andYielddateEqualTo(Date value) {
            addCriterion("YieldDate =", value, "yielddate");
            return (Criteria) this;
        }

        public Criteria andYielddateNotEqualTo(Date value) {
            addCriterion("YieldDate <>", value, "yielddate");
            return (Criteria) this;
        }

        public Criteria andYielddateGreaterThan(Date value) {
            addCriterion("YieldDate >", value, "yielddate");
            return (Criteria) this;
        }

        public Criteria andYielddateGreaterThanOrEqualTo(Date value) {
            addCriterion("YieldDate >=", value, "yielddate");
            return (Criteria) this;
        }

        public Criteria andYielddateLessThan(Date value) {
            addCriterion("YieldDate <", value, "yielddate");
            return (Criteria) this;
        }

        public Criteria andYielddateLessThanOrEqualTo(Date value) {
            addCriterion("YieldDate <=", value, "yielddate");
            return (Criteria) this;
        }

        public Criteria andYielddateIn(List<Date> values) {
            addCriterion("YieldDate in", values, "yielddate");
            return (Criteria) this;
        }

        public Criteria andYielddateNotIn(List<Date> values) {
            addCriterion("YieldDate not in", values, "yielddate");
            return (Criteria) this;
        }

        public Criteria andYielddateBetween(Date value1, Date value2) {
            addCriterion("YieldDate between", value1, value2, "yielddate");
            return (Criteria) this;
        }

        public Criteria andYielddateNotBetween(Date value1, Date value2) {
            addCriterion("YieldDate not between", value1, value2, "yielddate");
            return (Criteria) this;
        }

        public Criteria andIndateIsNull() {
            addCriterion("InDate is null");
            return (Criteria) this;
        }

        public Criteria andIndateIsNotNull() {
            addCriterion("InDate is not null");
            return (Criteria) this;
        }

        public Criteria andIndateEqualTo(Date value) {
            addCriterion("InDate =", value, "indate");
            return (Criteria) this;
        }

        public Criteria andIndateNotEqualTo(Date value) {
            addCriterion("InDate <>", value, "indate");
            return (Criteria) this;
        }

        public Criteria andIndateGreaterThan(Date value) {
            addCriterion("InDate >", value, "indate");
            return (Criteria) this;
        }

        public Criteria andIndateGreaterThanOrEqualTo(Date value) {
            addCriterion("InDate >=", value, "indate");
            return (Criteria) this;
        }

        public Criteria andIndateLessThan(Date value) {
            addCriterion("InDate <", value, "indate");
            return (Criteria) this;
        }

        public Criteria andIndateLessThanOrEqualTo(Date value) {
            addCriterion("InDate <=", value, "indate");
            return (Criteria) this;
        }

        public Criteria andIndateIn(List<Date> values) {
            addCriterion("InDate in", values, "indate");
            return (Criteria) this;
        }

        public Criteria andIndateNotIn(List<Date> values) {
            addCriterion("InDate not in", values, "indate");
            return (Criteria) this;
        }

        public Criteria andIndateBetween(Date value1, Date value2) {
            addCriterion("InDate between", value1, value2, "indate");
            return (Criteria) this;
        }

        public Criteria andIndateNotBetween(Date value1, Date value2) {
            addCriterion("InDate not between", value1, value2, "indate");
            return (Criteria) this;
        }

        public Criteria andPcsIsNull() {
            addCriterion("Pcs is null");
            return (Criteria) this;
        }

        public Criteria andPcsIsNotNull() {
            addCriterion("Pcs is not null");
            return (Criteria) this;
        }

        public Criteria andPcsEqualTo(Integer value) {
            addCriterion("Pcs =", value, "pcs");
            return (Criteria) this;
        }

        public Criteria andPcsNotEqualTo(Integer value) {
            addCriterion("Pcs <>", value, "pcs");
            return (Criteria) this;
        }

        public Criteria andPcsGreaterThan(Integer value) {
            addCriterion("Pcs >", value, "pcs");
            return (Criteria) this;
        }

        public Criteria andPcsGreaterThanOrEqualTo(Integer value) {
            addCriterion("Pcs >=", value, "pcs");
            return (Criteria) this;
        }

        public Criteria andPcsLessThan(Integer value) {
            addCriterion("Pcs <", value, "pcs");
            return (Criteria) this;
        }

        public Criteria andPcsLessThanOrEqualTo(Integer value) {
            addCriterion("Pcs <=", value, "pcs");
            return (Criteria) this;
        }

        public Criteria andPcsIn(List<Integer> values) {
            addCriterion("Pcs in", values, "pcs");
            return (Criteria) this;
        }

        public Criteria andPcsNotIn(List<Integer> values) {
            addCriterion("Pcs not in", values, "pcs");
            return (Criteria) this;
        }

        public Criteria andPcsBetween(Integer value1, Integer value2) {
            addCriterion("Pcs between", value1, value2, "pcs");
            return (Criteria) this;
        }

        public Criteria andPcsNotBetween(Integer value1, Integer value2) {
            addCriterion("Pcs not between", value1, value2, "pcs");
            return (Criteria) this;
        }

        public Criteria andOddIsNull() {
            addCriterion("Odd is null");
            return (Criteria) this;
        }

        public Criteria andOddIsNotNull() {
            addCriterion("Odd is not null");
            return (Criteria) this;
        }

        public Criteria andOddEqualTo(BigDecimal value) {
            addCriterion("Odd =", value, "odd");
            return (Criteria) this;
        }

        public Criteria andOddNotEqualTo(BigDecimal value) {
            addCriterion("Odd <>", value, "odd");
            return (Criteria) this;
        }

        public Criteria andOddGreaterThan(BigDecimal value) {
            addCriterion("Odd >", value, "odd");
            return (Criteria) this;
        }

        public Criteria andOddGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Odd >=", value, "odd");
            return (Criteria) this;
        }

        public Criteria andOddLessThan(BigDecimal value) {
            addCriterion("Odd <", value, "odd");
            return (Criteria) this;
        }

        public Criteria andOddLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Odd <=", value, "odd");
            return (Criteria) this;
        }

        public Criteria andOddIn(List<BigDecimal> values) {
            addCriterion("Odd in", values, "odd");
            return (Criteria) this;
        }

        public Criteria andOddNotIn(List<BigDecimal> values) {
            addCriterion("Odd not in", values, "odd");
            return (Criteria) this;
        }

        public Criteria andOddBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Odd between", value1, value2, "odd");
            return (Criteria) this;
        }

        public Criteria andOddNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Odd not between", value1, value2, "odd");
            return (Criteria) this;
        }

        public Criteria andQtyIsNull() {
            addCriterion("Qty is null");
            return (Criteria) this;
        }

        public Criteria andQtyIsNotNull() {
            addCriterion("Qty is not null");
            return (Criteria) this;
        }

        public Criteria andQtyEqualTo(BigDecimal value) {
            addCriterion("Qty =", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyNotEqualTo(BigDecimal value) {
            addCriterion("Qty <>", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyGreaterThan(BigDecimal value) {
            addCriterion("Qty >", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Qty >=", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyLessThan(BigDecimal value) {
            addCriterion("Qty <", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Qty <=", value, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyIn(List<BigDecimal> values) {
            addCriterion("Qty in", values, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyNotIn(List<BigDecimal> values) {
            addCriterion("Qty not in", values, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Qty between", value1, value2, "qty");
            return (Criteria) this;
        }

        public Criteria andQtyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Qty not between", value1, value2, "qty");
            return (Criteria) this;
        }

        public Criteria andWpcsIsNull() {
            addCriterion("WPcs is null");
            return (Criteria) this;
        }

        public Criteria andWpcsIsNotNull() {
            addCriterion("WPcs is not null");
            return (Criteria) this;
        }

        public Criteria andWpcsEqualTo(Integer value) {
            addCriterion("WPcs =", value, "wpcs");
            return (Criteria) this;
        }

        public Criteria andWpcsNotEqualTo(Integer value) {
            addCriterion("WPcs <>", value, "wpcs");
            return (Criteria) this;
        }

        public Criteria andWpcsGreaterThan(Integer value) {
            addCriterion("WPcs >", value, "wpcs");
            return (Criteria) this;
        }

        public Criteria andWpcsGreaterThanOrEqualTo(Integer value) {
            addCriterion("WPcs >=", value, "wpcs");
            return (Criteria) this;
        }

        public Criteria andWpcsLessThan(Integer value) {
            addCriterion("WPcs <", value, "wpcs");
            return (Criteria) this;
        }

        public Criteria andWpcsLessThanOrEqualTo(Integer value) {
            addCriterion("WPcs <=", value, "wpcs");
            return (Criteria) this;
        }

        public Criteria andWpcsIn(List<Integer> values) {
            addCriterion("WPcs in", values, "wpcs");
            return (Criteria) this;
        }

        public Criteria andWpcsNotIn(List<Integer> values) {
            addCriterion("WPcs not in", values, "wpcs");
            return (Criteria) this;
        }

        public Criteria andWpcsBetween(Integer value1, Integer value2) {
            addCriterion("WPcs between", value1, value2, "wpcs");
            return (Criteria) this;
        }

        public Criteria andWpcsNotBetween(Integer value1, Integer value2) {
            addCriterion("WPcs not between", value1, value2, "wpcs");
            return (Criteria) this;
        }

        public Criteria andWoddIsNull() {
            addCriterion("WOdd is null");
            return (Criteria) this;
        }

        public Criteria andWoddIsNotNull() {
            addCriterion("WOdd is not null");
            return (Criteria) this;
        }

        public Criteria andWoddEqualTo(BigDecimal value) {
            addCriterion("WOdd =", value, "wodd");
            return (Criteria) this;
        }

        public Criteria andWoddNotEqualTo(BigDecimal value) {
            addCriterion("WOdd <>", value, "wodd");
            return (Criteria) this;
        }

        public Criteria andWoddGreaterThan(BigDecimal value) {
            addCriterion("WOdd >", value, "wodd");
            return (Criteria) this;
        }

        public Criteria andWoddGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("WOdd >=", value, "wodd");
            return (Criteria) this;
        }

        public Criteria andWoddLessThan(BigDecimal value) {
            addCriterion("WOdd <", value, "wodd");
            return (Criteria) this;
        }

        public Criteria andWoddLessThanOrEqualTo(BigDecimal value) {
            addCriterion("WOdd <=", value, "wodd");
            return (Criteria) this;
        }

        public Criteria andWoddIn(List<BigDecimal> values) {
            addCriterion("WOdd in", values, "wodd");
            return (Criteria) this;
        }

        public Criteria andWoddNotIn(List<BigDecimal> values) {
            addCriterion("WOdd not in", values, "wodd");
            return (Criteria) this;
        }

        public Criteria andWoddBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WOdd between", value1, value2, "wodd");
            return (Criteria) this;
        }

        public Criteria andWoddNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WOdd not between", value1, value2, "wodd");
            return (Criteria) this;
        }

        public Criteria andWqtyIsNull() {
            addCriterion("WQty is null");
            return (Criteria) this;
        }

        public Criteria andWqtyIsNotNull() {
            addCriterion("WQty is not null");
            return (Criteria) this;
        }

        public Criteria andWqtyEqualTo(BigDecimal value) {
            addCriterion("WQty =", value, "wqty");
            return (Criteria) this;
        }

        public Criteria andWqtyNotEqualTo(BigDecimal value) {
            addCriterion("WQty <>", value, "wqty");
            return (Criteria) this;
        }

        public Criteria andWqtyGreaterThan(BigDecimal value) {
            addCriterion("WQty >", value, "wqty");
            return (Criteria) this;
        }

        public Criteria andWqtyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("WQty >=", value, "wqty");
            return (Criteria) this;
        }

        public Criteria andWqtyLessThan(BigDecimal value) {
            addCriterion("WQty <", value, "wqty");
            return (Criteria) this;
        }

        public Criteria andWqtyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("WQty <=", value, "wqty");
            return (Criteria) this;
        }

        public Criteria andWqtyIn(List<BigDecimal> values) {
            addCriterion("WQty in", values, "wqty");
            return (Criteria) this;
        }

        public Criteria andWqtyNotIn(List<BigDecimal> values) {
            addCriterion("WQty not in", values, "wqty");
            return (Criteria) this;
        }

        public Criteria andWqtyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WQty between", value1, value2, "wqty");
            return (Criteria) this;
        }

        public Criteria andWqtyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WQty not between", value1, value2, "wqty");
            return (Criteria) this;
        }

        public Criteria andWasterflagIsNull() {
            addCriterion("WasterFlag is null");
            return (Criteria) this;
        }

        public Criteria andWasterflagIsNotNull() {
            addCriterion("WasterFlag is not null");
            return (Criteria) this;
        }

        public Criteria andWasterflagEqualTo(String value) {
            addCriterion("WasterFlag =", value, "wasterflag");
            return (Criteria) this;
        }

        public Criteria andWasterflagNotEqualTo(String value) {
            addCriterion("WasterFlag <>", value, "wasterflag");
            return (Criteria) this;
        }

        public Criteria andWasterflagGreaterThan(String value) {
            addCriterion("WasterFlag >", value, "wasterflag");
            return (Criteria) this;
        }

        public Criteria andWasterflagGreaterThanOrEqualTo(String value) {
            addCriterion("WasterFlag >=", value, "wasterflag");
            return (Criteria) this;
        }

        public Criteria andWasterflagLessThan(String value) {
            addCriterion("WasterFlag <", value, "wasterflag");
            return (Criteria) this;
        }

        public Criteria andWasterflagLessThanOrEqualTo(String value) {
            addCriterion("WasterFlag <=", value, "wasterflag");
            return (Criteria) this;
        }

        public Criteria andWasterflagLike(String value) {
            addCriterion("WasterFlag like", value, "wasterflag");
            return (Criteria) this;
        }

        public Criteria andWasterflagNotLike(String value) {
            addCriterion("WasterFlag not like", value, "wasterflag");
            return (Criteria) this;
        }

        public Criteria andWasterflagIn(List<String> values) {
            addCriterion("WasterFlag in", values, "wasterflag");
            return (Criteria) this;
        }

        public Criteria andWasterflagNotIn(List<String> values) {
            addCriterion("WasterFlag not in", values, "wasterflag");
            return (Criteria) this;
        }

        public Criteria andWasterflagBetween(String value1, String value2) {
            addCriterion("WasterFlag between", value1, value2, "wasterflag");
            return (Criteria) this;
        }

        public Criteria andWasterflagNotBetween(String value1, String value2) {
            addCriterion("WasterFlag not between", value1, value2, "wasterflag");
            return (Criteria) this;
        }

        public Criteria andDistflagIsNull() {
            addCriterion("DistFlag is null");
            return (Criteria) this;
        }

        public Criteria andDistflagIsNotNull() {
            addCriterion("DistFlag is not null");
            return (Criteria) this;
        }

        public Criteria andDistflagEqualTo(String value) {
            addCriterion("DistFlag =", value, "distflag");
            return (Criteria) this;
        }

        public Criteria andDistflagNotEqualTo(String value) {
            addCriterion("DistFlag <>", value, "distflag");
            return (Criteria) this;
        }

        public Criteria andDistflagGreaterThan(String value) {
            addCriterion("DistFlag >", value, "distflag");
            return (Criteria) this;
        }

        public Criteria andDistflagGreaterThanOrEqualTo(String value) {
            addCriterion("DistFlag >=", value, "distflag");
            return (Criteria) this;
        }

        public Criteria andDistflagLessThan(String value) {
            addCriterion("DistFlag <", value, "distflag");
            return (Criteria) this;
        }

        public Criteria andDistflagLessThanOrEqualTo(String value) {
            addCriterion("DistFlag <=", value, "distflag");
            return (Criteria) this;
        }

        public Criteria andDistflagLike(String value) {
            addCriterion("DistFlag like", value, "distflag");
            return (Criteria) this;
        }

        public Criteria andDistflagNotLike(String value) {
            addCriterion("DistFlag not like", value, "distflag");
            return (Criteria) this;
        }

        public Criteria andDistflagIn(List<String> values) {
            addCriterion("DistFlag in", values, "distflag");
            return (Criteria) this;
        }

        public Criteria andDistflagNotIn(List<String> values) {
            addCriterion("DistFlag not in", values, "distflag");
            return (Criteria) this;
        }

        public Criteria andDistflagBetween(String value1, String value2) {
            addCriterion("DistFlag between", value1, value2, "distflag");
            return (Criteria) this;
        }

        public Criteria andDistflagNotBetween(String value1, String value2) {
            addCriterion("DistFlag not between", value1, value2, "distflag");
            return (Criteria) this;
        }

        public Criteria andDistdateIsNull() {
            addCriterion("DistDate is null");
            return (Criteria) this;
        }

        public Criteria andDistdateIsNotNull() {
            addCriterion("DistDate is not null");
            return (Criteria) this;
        }

        public Criteria andDistdateEqualTo(Date value) {
            addCriterion("DistDate =", value, "distdate");
            return (Criteria) this;
        }

        public Criteria andDistdateNotEqualTo(Date value) {
            addCriterion("DistDate <>", value, "distdate");
            return (Criteria) this;
        }

        public Criteria andDistdateGreaterThan(Date value) {
            addCriterion("DistDate >", value, "distdate");
            return (Criteria) this;
        }

        public Criteria andDistdateGreaterThanOrEqualTo(Date value) {
            addCriterion("DistDate >=", value, "distdate");
            return (Criteria) this;
        }

        public Criteria andDistdateLessThan(Date value) {
            addCriterion("DistDate <", value, "distdate");
            return (Criteria) this;
        }

        public Criteria andDistdateLessThanOrEqualTo(Date value) {
            addCriterion("DistDate <=", value, "distdate");
            return (Criteria) this;
        }

        public Criteria andDistdateIn(List<Date> values) {
            addCriterion("DistDate in", values, "distdate");
            return (Criteria) this;
        }

        public Criteria andDistdateNotIn(List<Date> values) {
            addCriterion("DistDate not in", values, "distdate");
            return (Criteria) this;
        }

        public Criteria andDistdateBetween(Date value1, Date value2) {
            addCriterion("DistDate between", value1, value2, "distdate");
            return (Criteria) this;
        }

        public Criteria andDistdateNotBetween(Date value1, Date value2) {
            addCriterion("DistDate not between", value1, value2, "distdate");
            return (Criteria) this;
        }

        public Criteria andAvgpriceIsNull() {
            addCriterion("AvgPrice is null");
            return (Criteria) this;
        }

        public Criteria andAvgpriceIsNotNull() {
            addCriterion("AvgPrice is not null");
            return (Criteria) this;
        }

        public Criteria andAvgpriceEqualTo(BigDecimal value) {
            addCriterion("AvgPrice =", value, "avgprice");
            return (Criteria) this;
        }

        public Criteria andAvgpriceNotEqualTo(BigDecimal value) {
            addCriterion("AvgPrice <>", value, "avgprice");
            return (Criteria) this;
        }

        public Criteria andAvgpriceGreaterThan(BigDecimal value) {
            addCriterion("AvgPrice >", value, "avgprice");
            return (Criteria) this;
        }

        public Criteria andAvgpriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("AvgPrice >=", value, "avgprice");
            return (Criteria) this;
        }

        public Criteria andAvgpriceLessThan(BigDecimal value) {
            addCriterion("AvgPrice <", value, "avgprice");
            return (Criteria) this;
        }

        public Criteria andAvgpriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("AvgPrice <=", value, "avgprice");
            return (Criteria) this;
        }

        public Criteria andAvgpriceIn(List<BigDecimal> values) {
            addCriterion("AvgPrice in", values, "avgprice");
            return (Criteria) this;
        }

        public Criteria andAvgpriceNotIn(List<BigDecimal> values) {
            addCriterion("AvgPrice not in", values, "avgprice");
            return (Criteria) this;
        }

        public Criteria andAvgpriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AvgPrice between", value1, value2, "avgprice");
            return (Criteria) this;
        }

        public Criteria andAvgpriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AvgPrice not between", value1, value2, "avgprice");
            return (Criteria) this;
        }

        public Criteria andAvgnetpriceIsNull() {
            addCriterion("AvgNetPrice is null");
            return (Criteria) this;
        }

        public Criteria andAvgnetpriceIsNotNull() {
            addCriterion("AvgNetPrice is not null");
            return (Criteria) this;
        }

        public Criteria andAvgnetpriceEqualTo(BigDecimal value) {
            addCriterion("AvgNetPrice =", value, "avgnetprice");
            return (Criteria) this;
        }

        public Criteria andAvgnetpriceNotEqualTo(BigDecimal value) {
            addCriterion("AvgNetPrice <>", value, "avgnetprice");
            return (Criteria) this;
        }

        public Criteria andAvgnetpriceGreaterThan(BigDecimal value) {
            addCriterion("AvgNetPrice >", value, "avgnetprice");
            return (Criteria) this;
        }

        public Criteria andAvgnetpriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("AvgNetPrice >=", value, "avgnetprice");
            return (Criteria) this;
        }

        public Criteria andAvgnetpriceLessThan(BigDecimal value) {
            addCriterion("AvgNetPrice <", value, "avgnetprice");
            return (Criteria) this;
        }

        public Criteria andAvgnetpriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("AvgNetPrice <=", value, "avgnetprice");
            return (Criteria) this;
        }

        public Criteria andAvgnetpriceIn(List<BigDecimal> values) {
            addCriterion("AvgNetPrice in", values, "avgnetprice");
            return (Criteria) this;
        }

        public Criteria andAvgnetpriceNotIn(List<BigDecimal> values) {
            addCriterion("AvgNetPrice not in", values, "avgnetprice");
            return (Criteria) this;
        }

        public Criteria andAvgnetpriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AvgNetPrice between", value1, value2, "avgnetprice");
            return (Criteria) this;
        }

        public Criteria andAvgnetpriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("AvgNetPrice not between", value1, value2, "avgnetprice");
            return (Criteria) this;
        }

        public Criteria andCostIsNull() {
            addCriterion("Cost is null");
            return (Criteria) this;
        }

        public Criteria andCostIsNotNull() {
            addCriterion("Cost is not null");
            return (Criteria) this;
        }

        public Criteria andCostEqualTo(BigDecimal value) {
            addCriterion("Cost =", value, "cost");
            return (Criteria) this;
        }

        public Criteria andCostNotEqualTo(BigDecimal value) {
            addCriterion("Cost <>", value, "cost");
            return (Criteria) this;
        }

        public Criteria andCostGreaterThan(BigDecimal value) {
            addCriterion("Cost >", value, "cost");
            return (Criteria) this;
        }

        public Criteria andCostGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Cost >=", value, "cost");
            return (Criteria) this;
        }

        public Criteria andCostLessThan(BigDecimal value) {
            addCriterion("Cost <", value, "cost");
            return (Criteria) this;
        }

        public Criteria andCostLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Cost <=", value, "cost");
            return (Criteria) this;
        }

        public Criteria andCostIn(List<BigDecimal> values) {
            addCriterion("Cost in", values, "cost");
            return (Criteria) this;
        }

        public Criteria andCostNotIn(List<BigDecimal> values) {
            addCriterion("Cost not in", values, "cost");
            return (Criteria) this;
        }

        public Criteria andCostBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Cost between", value1, value2, "cost");
            return (Criteria) this;
        }

        public Criteria andCostNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Cost not between", value1, value2, "cost");
            return (Criteria) this;
        }

        public Criteria andNetcostIsNull() {
            addCriterion("NetCost is null");
            return (Criteria) this;
        }

        public Criteria andNetcostIsNotNull() {
            addCriterion("NetCost is not null");
            return (Criteria) this;
        }

        public Criteria andNetcostEqualTo(BigDecimal value) {
            addCriterion("NetCost =", value, "netcost");
            return (Criteria) this;
        }

        public Criteria andNetcostNotEqualTo(BigDecimal value) {
            addCriterion("NetCost <>", value, "netcost");
            return (Criteria) this;
        }

        public Criteria andNetcostGreaterThan(BigDecimal value) {
            addCriterion("NetCost >", value, "netcost");
            return (Criteria) this;
        }

        public Criteria andNetcostGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("NetCost >=", value, "netcost");
            return (Criteria) this;
        }

        public Criteria andNetcostLessThan(BigDecimal value) {
            addCriterion("NetCost <", value, "netcost");
            return (Criteria) this;
        }

        public Criteria andNetcostLessThanOrEqualTo(BigDecimal value) {
            addCriterion("NetCost <=", value, "netcost");
            return (Criteria) this;
        }

        public Criteria andNetcostIn(List<BigDecimal> values) {
            addCriterion("NetCost in", values, "netcost");
            return (Criteria) this;
        }

        public Criteria andNetcostNotIn(List<BigDecimal> values) {
            addCriterion("NetCost not in", values, "netcost");
            return (Criteria) this;
        }

        public Criteria andNetcostBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("NetCost between", value1, value2, "netcost");
            return (Criteria) this;
        }

        public Criteria andNetcostNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("NetCost not between", value1, value2, "netcost");
            return (Criteria) this;
        }

        public Criteria andBatchnoIsNull() {
            addCriterion("BatchNo is null");
            return (Criteria) this;
        }

        public Criteria andBatchnoIsNotNull() {
            addCriterion("BatchNo is not null");
            return (Criteria) this;
        }

        public Criteria andBatchnoEqualTo(String value) {
            addCriterion("BatchNo =", value, "batchno");
            return (Criteria) this;
        }

        public Criteria andBatchnoNotEqualTo(String value) {
            addCriterion("BatchNo <>", value, "batchno");
            return (Criteria) this;
        }

        public Criteria andBatchnoGreaterThan(String value) {
            addCriterion("BatchNo >", value, "batchno");
            return (Criteria) this;
        }

        public Criteria andBatchnoGreaterThanOrEqualTo(String value) {
            addCriterion("BatchNo >=", value, "batchno");
            return (Criteria) this;
        }

        public Criteria andBatchnoLessThan(String value) {
            addCriterion("BatchNo <", value, "batchno");
            return (Criteria) this;
        }

        public Criteria andBatchnoLessThanOrEqualTo(String value) {
            addCriterion("BatchNo <=", value, "batchno");
            return (Criteria) this;
        }

        public Criteria andBatchnoLike(String value) {
            addCriterion("BatchNo like", value, "batchno");
            return (Criteria) this;
        }

        public Criteria andBatchnoNotLike(String value) {
            addCriterion("BatchNo not like", value, "batchno");
            return (Criteria) this;
        }

        public Criteria andBatchnoIn(List<String> values) {
            addCriterion("BatchNo in", values, "batchno");
            return (Criteria) this;
        }

        public Criteria andBatchnoNotIn(List<String> values) {
            addCriterion("BatchNo not in", values, "batchno");
            return (Criteria) this;
        }

        public Criteria andBatchnoBetween(String value1, String value2) {
            addCriterion("BatchNo between", value1, value2, "batchno");
            return (Criteria) this;
        }

        public Criteria andBatchnoNotBetween(String value1, String value2) {
            addCriterion("BatchNo not between", value1, value2, "batchno");
            return (Criteria) this;
        }

        public Criteria andVendorcodeIsNull() {
            addCriterion("VendorCode is null");
            return (Criteria) this;
        }

        public Criteria andVendorcodeIsNotNull() {
            addCriterion("VendorCode is not null");
            return (Criteria) this;
        }

        public Criteria andVendorcodeEqualTo(String value) {
            addCriterion("VendorCode =", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeNotEqualTo(String value) {
            addCriterion("VendorCode <>", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeGreaterThan(String value) {
            addCriterion("VendorCode >", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeGreaterThanOrEqualTo(String value) {
            addCriterion("VendorCode >=", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeLessThan(String value) {
            addCriterion("VendorCode <", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeLessThanOrEqualTo(String value) {
            addCriterion("VendorCode <=", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeLike(String value) {
            addCriterion("VendorCode like", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeNotLike(String value) {
            addCriterion("VendorCode not like", value, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeIn(List<String> values) {
            addCriterion("VendorCode in", values, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeNotIn(List<String> values) {
            addCriterion("VendorCode not in", values, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeBetween(String value1, String value2) {
            addCriterion("VendorCode between", value1, value2, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andVendorcodeNotBetween(String value1, String value2) {
            addCriterion("VendorCode not between", value1, value2, "vendorcode");
            return (Criteria) this;
        }

        public Criteria andLockerIsNull() {
            addCriterion("Locker is null");
            return (Criteria) this;
        }

        public Criteria andLockerIsNotNull() {
            addCriterion("Locker is not null");
            return (Criteria) this;
        }

        public Criteria andLockerEqualTo(String value) {
            addCriterion("Locker =", value, "locker");
            return (Criteria) this;
        }

        public Criteria andLockerNotEqualTo(String value) {
            addCriterion("Locker <>", value, "locker");
            return (Criteria) this;
        }

        public Criteria andLockerGreaterThan(String value) {
            addCriterion("Locker >", value, "locker");
            return (Criteria) this;
        }

        public Criteria andLockerGreaterThanOrEqualTo(String value) {
            addCriterion("Locker >=", value, "locker");
            return (Criteria) this;
        }

        public Criteria andLockerLessThan(String value) {
            addCriterion("Locker <", value, "locker");
            return (Criteria) this;
        }

        public Criteria andLockerLessThanOrEqualTo(String value) {
            addCriterion("Locker <=", value, "locker");
            return (Criteria) this;
        }

        public Criteria andLockerLike(String value) {
            addCriterion("Locker like", value, "locker");
            return (Criteria) this;
        }

        public Criteria andLockerNotLike(String value) {
            addCriterion("Locker not like", value, "locker");
            return (Criteria) this;
        }

        public Criteria andLockerIn(List<String> values) {
            addCriterion("Locker in", values, "locker");
            return (Criteria) this;
        }

        public Criteria andLockerNotIn(List<String> values) {
            addCriterion("Locker not in", values, "locker");
            return (Criteria) this;
        }

        public Criteria andLockerBetween(String value1, String value2) {
            addCriterion("Locker between", value1, value2, "locker");
            return (Criteria) this;
        }

        public Criteria andLockerNotBetween(String value1, String value2) {
            addCriterion("Locker not between", value1, value2, "locker");
            return (Criteria) this;
        }

        public Criteria andLockwhyIsNull() {
            addCriterion("LockWhy is null");
            return (Criteria) this;
        }

        public Criteria andLockwhyIsNotNull() {
            addCriterion("LockWhy is not null");
            return (Criteria) this;
        }

        public Criteria andLockwhyEqualTo(String value) {
            addCriterion("LockWhy =", value, "lockwhy");
            return (Criteria) this;
        }

        public Criteria andLockwhyNotEqualTo(String value) {
            addCriterion("LockWhy <>", value, "lockwhy");
            return (Criteria) this;
        }

        public Criteria andLockwhyGreaterThan(String value) {
            addCriterion("LockWhy >", value, "lockwhy");
            return (Criteria) this;
        }

        public Criteria andLockwhyGreaterThanOrEqualTo(String value) {
            addCriterion("LockWhy >=", value, "lockwhy");
            return (Criteria) this;
        }

        public Criteria andLockwhyLessThan(String value) {
            addCriterion("LockWhy <", value, "lockwhy");
            return (Criteria) this;
        }

        public Criteria andLockwhyLessThanOrEqualTo(String value) {
            addCriterion("LockWhy <=", value, "lockwhy");
            return (Criteria) this;
        }

        public Criteria andLockwhyLike(String value) {
            addCriterion("LockWhy like", value, "lockwhy");
            return (Criteria) this;
        }

        public Criteria andLockwhyNotLike(String value) {
            addCriterion("LockWhy not like", value, "lockwhy");
            return (Criteria) this;
        }

        public Criteria andLockwhyIn(List<String> values) {
            addCriterion("LockWhy in", values, "lockwhy");
            return (Criteria) this;
        }

        public Criteria andLockwhyNotIn(List<String> values) {
            addCriterion("LockWhy not in", values, "lockwhy");
            return (Criteria) this;
        }

        public Criteria andLockwhyBetween(String value1, String value2) {
            addCriterion("LockWhy between", value1, value2, "lockwhy");
            return (Criteria) this;
        }

        public Criteria andLockwhyNotBetween(String value1, String value2) {
            addCriterion("LockWhy not between", value1, value2, "lockwhy");
            return (Criteria) this;
        }

        public Criteria andDistpriIsNull() {
            addCriterion("DistPRI is null");
            return (Criteria) this;
        }

        public Criteria andDistpriIsNotNull() {
            addCriterion("DistPRI is not null");
            return (Criteria) this;
        }

        public Criteria andDistpriEqualTo(Integer value) {
            addCriterion("DistPRI =", value, "distpri");
            return (Criteria) this;
        }

        public Criteria andDistpriNotEqualTo(Integer value) {
            addCriterion("DistPRI <>", value, "distpri");
            return (Criteria) this;
        }

        public Criteria andDistpriGreaterThan(Integer value) {
            addCriterion("DistPRI >", value, "distpri");
            return (Criteria) this;
        }

        public Criteria andDistpriGreaterThanOrEqualTo(Integer value) {
            addCriterion("DistPRI >=", value, "distpri");
            return (Criteria) this;
        }

        public Criteria andDistpriLessThan(Integer value) {
            addCriterion("DistPRI <", value, "distpri");
            return (Criteria) this;
        }

        public Criteria andDistpriLessThanOrEqualTo(Integer value) {
            addCriterion("DistPRI <=", value, "distpri");
            return (Criteria) this;
        }

        public Criteria andDistpriIn(List<Integer> values) {
            addCriterion("DistPRI in", values, "distpri");
            return (Criteria) this;
        }

        public Criteria andDistpriNotIn(List<Integer> values) {
            addCriterion("DistPRI not in", values, "distpri");
            return (Criteria) this;
        }

        public Criteria andDistpriBetween(Integer value1, Integer value2) {
            addCriterion("DistPRI between", value1, value2, "distpri");
            return (Criteria) this;
        }

        public Criteria andDistpriNotBetween(Integer value1, Integer value2) {
            addCriterion("DistPRI not between", value1, value2, "distpri");
            return (Criteria) this;
        }

        public Criteria andGrnbillnoIsNull() {
            addCriterion("GrnBillNo is null");
            return (Criteria) this;
        }

        public Criteria andGrnbillnoIsNotNull() {
            addCriterion("GrnBillNo is not null");
            return (Criteria) this;
        }

        public Criteria andGrnbillnoEqualTo(String value) {
            addCriterion("GrnBillNo =", value, "grnbillno");
            return (Criteria) this;
        }

        public Criteria andGrnbillnoNotEqualTo(String value) {
            addCriterion("GrnBillNo <>", value, "grnbillno");
            return (Criteria) this;
        }

        public Criteria andGrnbillnoGreaterThan(String value) {
            addCriterion("GrnBillNo >", value, "grnbillno");
            return (Criteria) this;
        }

        public Criteria andGrnbillnoGreaterThanOrEqualTo(String value) {
            addCriterion("GrnBillNo >=", value, "grnbillno");
            return (Criteria) this;
        }

        public Criteria andGrnbillnoLessThan(String value) {
            addCriterion("GrnBillNo <", value, "grnbillno");
            return (Criteria) this;
        }

        public Criteria andGrnbillnoLessThanOrEqualTo(String value) {
            addCriterion("GrnBillNo <=", value, "grnbillno");
            return (Criteria) this;
        }

        public Criteria andGrnbillnoLike(String value) {
            addCriterion("GrnBillNo like", value, "grnbillno");
            return (Criteria) this;
        }

        public Criteria andGrnbillnoNotLike(String value) {
            addCriterion("GrnBillNo not like", value, "grnbillno");
            return (Criteria) this;
        }

        public Criteria andGrnbillnoIn(List<String> values) {
            addCriterion("GrnBillNo in", values, "grnbillno");
            return (Criteria) this;
        }

        public Criteria andGrnbillnoNotIn(List<String> values) {
            addCriterion("GrnBillNo not in", values, "grnbillno");
            return (Criteria) this;
        }

        public Criteria andGrnbillnoBetween(String value1, String value2) {
            addCriterion("GrnBillNo between", value1, value2, "grnbillno");
            return (Criteria) this;
        }

        public Criteria andGrnbillnoNotBetween(String value1, String value2) {
            addCriterion("GrnBillNo not between", value1, value2, "grnbillno");
            return (Criteria) this;
        }

        public Criteria andStoragedateIsNull() {
            addCriterion("StorageDate is null");
            return (Criteria) this;
        }

        public Criteria andStoragedateIsNotNull() {
            addCriterion("StorageDate is not null");
            return (Criteria) this;
        }

        public Criteria andStoragedateEqualTo(Date value) {
            addCriterion("StorageDate =", value, "storagedate");
            return (Criteria) this;
        }

        public Criteria andStoragedateNotEqualTo(Date value) {
            addCriterion("StorageDate <>", value, "storagedate");
            return (Criteria) this;
        }

        public Criteria andStoragedateGreaterThan(Date value) {
            addCriterion("StorageDate >", value, "storagedate");
            return (Criteria) this;
        }

        public Criteria andStoragedateGreaterThanOrEqualTo(Date value) {
            addCriterion("StorageDate >=", value, "storagedate");
            return (Criteria) this;
        }

        public Criteria andStoragedateLessThan(Date value) {
            addCriterion("StorageDate <", value, "storagedate");
            return (Criteria) this;
        }

        public Criteria andStoragedateLessThanOrEqualTo(Date value) {
            addCriterion("StorageDate <=", value, "storagedate");
            return (Criteria) this;
        }

        public Criteria andStoragedateIn(List<Date> values) {
            addCriterion("StorageDate in", values, "storagedate");
            return (Criteria) this;
        }

        public Criteria andStoragedateNotIn(List<Date> values) {
            addCriterion("StorageDate not in", values, "storagedate");
            return (Criteria) this;
        }

        public Criteria andStoragedateBetween(Date value1, Date value2) {
            addCriterion("StorageDate between", value1, value2, "storagedate");
            return (Criteria) this;
        }

        public Criteria andStoragedateNotBetween(Date value1, Date value2) {
            addCriterion("StorageDate not between", value1, value2, "storagedate");
            return (Criteria) this;
        }

        public Criteria andUseridIsNull() {
            addCriterion("UserID is null");
            return (Criteria) this;
        }

        public Criteria andUseridIsNotNull() {
            addCriterion("UserID is not null");
            return (Criteria) this;
        }

        public Criteria andUseridEqualTo(String value) {
            addCriterion("UserID =", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotEqualTo(String value) {
            addCriterion("UserID <>", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThan(String value) {
            addCriterion("UserID >", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThanOrEqualTo(String value) {
            addCriterion("UserID >=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThan(String value) {
            addCriterion("UserID <", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThanOrEqualTo(String value) {
            addCriterion("UserID <=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLike(String value) {
            addCriterion("UserID like", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotLike(String value) {
            addCriterion("UserID not like", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridIn(List<String> values) {
            addCriterion("UserID in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotIn(List<String> values) {
            addCriterion("UserID not in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridBetween(String value1, String value2) {
            addCriterion("UserID between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotBetween(String value1, String value2) {
            addCriterion("UserID not between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andBarcodeIsNull() {
            addCriterion("BarCode is null");
            return (Criteria) this;
        }

        public Criteria andBarcodeIsNotNull() {
            addCriterion("BarCode is not null");
            return (Criteria) this;
        }

        public Criteria andBarcodeEqualTo(String value) {
            addCriterion("BarCode =", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeNotEqualTo(String value) {
            addCriterion("BarCode <>", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeGreaterThan(String value) {
            addCriterion("BarCode >", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeGreaterThanOrEqualTo(String value) {
            addCriterion("BarCode >=", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeLessThan(String value) {
            addCriterion("BarCode <", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeLessThanOrEqualTo(String value) {
            addCriterion("BarCode <=", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeLike(String value) {
            addCriterion("BarCode like", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeNotLike(String value) {
            addCriterion("BarCode not like", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeIn(List<String> values) {
            addCriterion("BarCode in", values, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeNotIn(List<String> values) {
            addCriterion("BarCode not in", values, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeBetween(String value1, String value2) {
            addCriterion("BarCode between", value1, value2, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeNotBetween(String value1, String value2) {
            addCriterion("BarCode not between", value1, value2, "barcode");
            return (Criteria) this;
        }

        public Criteria andOutflagIsNull() {
            addCriterion("OutFlag is null");
            return (Criteria) this;
        }

        public Criteria andOutflagIsNotNull() {
            addCriterion("OutFlag is not null");
            return (Criteria) this;
        }

        public Criteria andOutflagEqualTo(String value) {
            addCriterion("OutFlag =", value, "outflag");
            return (Criteria) this;
        }

        public Criteria andOutflagNotEqualTo(String value) {
            addCriterion("OutFlag <>", value, "outflag");
            return (Criteria) this;
        }

        public Criteria andOutflagGreaterThan(String value) {
            addCriterion("OutFlag >", value, "outflag");
            return (Criteria) this;
        }

        public Criteria andOutflagGreaterThanOrEqualTo(String value) {
            addCriterion("OutFlag >=", value, "outflag");
            return (Criteria) this;
        }

        public Criteria andOutflagLessThan(String value) {
            addCriterion("OutFlag <", value, "outflag");
            return (Criteria) this;
        }

        public Criteria andOutflagLessThanOrEqualTo(String value) {
            addCriterion("OutFlag <=", value, "outflag");
            return (Criteria) this;
        }

        public Criteria andOutflagLike(String value) {
            addCriterion("OutFlag like", value, "outflag");
            return (Criteria) this;
        }

        public Criteria andOutflagNotLike(String value) {
            addCriterion("OutFlag not like", value, "outflag");
            return (Criteria) this;
        }

        public Criteria andOutflagIn(List<String> values) {
            addCriterion("OutFlag in", values, "outflag");
            return (Criteria) this;
        }

        public Criteria andOutflagNotIn(List<String> values) {
            addCriterion("OutFlag not in", values, "outflag");
            return (Criteria) this;
        }

        public Criteria andOutflagBetween(String value1, String value2) {
            addCriterion("OutFlag between", value1, value2, "outflag");
            return (Criteria) this;
        }

        public Criteria andOutflagNotBetween(String value1, String value2) {
            addCriterion("OutFlag not between", value1, value2, "outflag");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}